UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'BtVPUUd/ckOcuUntAi6pSPOSYNNeHeFD05J9ObYI8rU='
WHERE
key_id = 'd620b9d0194be63c5986c8f04cc388bcf14d1eae9be8bba94ea38321699cd32b'
AND (
token = 'BtVPUUd/ckOcuUntAi6pSPOSYNNeHeFD05J9ObYI8rU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)