UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'fpyu0NAZ80u7FD38GMgvjl3NFU0uw8J9cJ9EAIEG+gg='
WHERE
key_id = 'b37a0204aeb7f8a975f9133aeeee9333d2ef14fa2898e8c8d4b6cecd9f1ec3f8'
AND (
token = 'fpyu0NAZ80u7FD38GMgvjl3NFU0uw8J9cJ9EAIEG+gg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)