UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'TUkdXgrcgdZpgFJam6mCSxtNx07gJwb8QRtXL0pte6o='
WHERE
key_id = '31c77e4844ce00db1da0e93a512c13dc72f9256a887feeffb5afdb80cd140422'
AND (
token = 'TUkdXgrcgdZpgFJam6mCSxtNx07gJwb8QRtXL0pte6o='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)