UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'nXYIYYznrHACqkFQUtEvWpQ+HiPZQGlnslANfYA2ir0='
WHERE
key_id = '4118af32f50468a14602fa6d08794649094dfa2f174511abb811d1ada64d3d31'
AND (
token = 'nXYIYYznrHACqkFQUtEvWpQ+HiPZQGlnslANfYA2ir0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)