UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'nKB+6esV5Gx64nLbbKV5Eb0ACeHHyywt4X0idortGwA='
WHERE
key_id = '9236056e739934246f79338b9ed650a8ea48cf2d30ca36cd4f72c2c8359467af'
AND (
token = 'nKB+6esV5Gx64nLbbKV5Eb0ACeHHyywt4X0idortGwA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)