UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'R8EHqzkqZGACsgCx3B6q+HNUSzXkWcI1w9h36vWTkn8='
WHERE
key_id = 'bc384be78957cccd363e4766096f2881b6b6e188a581050d28c16c17ac672bdf'
AND (
token = 'R8EHqzkqZGACsgCx3B6q+HNUSzXkWcI1w9h36vWTkn8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)