UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'mcAs6sr9EnajM+iCSYR9CnhA0WjywbiXcO3hsAwijoo='
WHERE
key_id = '1e9d648bf38f7175b0c796df78cd7b83982d8d84ccc68f1bc17179d76a724679'
AND (
token = 'mcAs6sr9EnajM+iCSYR9CnhA0WjywbiXcO3hsAwijoo='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)