UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '1o/3KQfQwxgHY8gWxIUVKPTtls09pnkc5lrsKxrwu3Q='
WHERE
key_id = 'ac6bcc7ec43042f88578bb34ffac3e75f0cf7f99730cc8b5bb35f35803ab5813'
AND (
token = '1o/3KQfQwxgHY8gWxIUVKPTtls09pnkc5lrsKxrwu3Q='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)