UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'X4hF90e8gKgL3LHqvty4+3YutSe6dEAIvQUmWhj2cao='
WHERE
key_id = '5f193348fe33e97d10c921b2f5cce4f233cf799c519cd1cc35584ed3746c1127'
AND (
token = 'X4hF90e8gKgL3LHqvty4+3YutSe6dEAIvQUmWhj2cao='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)