UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'viRsSV04qtKZohRSKAkfYDu6cpzx2tZnCMPC3LPANRc='
WHERE
key_id = '0bbf57c97fa8fa84952b950ddb37bc3977170f9c7877aeae260662e56f2b51b5'
AND (
token = 'viRsSV04qtKZohRSKAkfYDu6cpzx2tZnCMPC3LPANRc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)