UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'zs2Wa/AZ6pxqZESomg3s9jwjdqHUhHLPNyl2TQyQ1Io='
WHERE
key_id = 'c0e2fbdc283a25c6a0c532f5e2ad5ddfebf2103719211e50ffe0ad62398a833f'
AND (
token = 'zs2Wa/AZ6pxqZESomg3s9jwjdqHUhHLPNyl2TQyQ1Io='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)