UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'o1SAQNyu9hChwiXm6qQG+nXdqoo+i7ldEOIesnb8msg='
WHERE
key_id = 'e4505a8b468b2bb9f9e9208e3e0caa73880bfd9539865bae958e8484642b8f23'
AND (
token = 'o1SAQNyu9hChwiXm6qQG+nXdqoo+i7ldEOIesnb8msg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)