UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'YH0/eXLrbvh5IVm49pKZHMOkfMK4Iwb29lKF7wSWefU='
WHERE
key_id = 'd977621c1ce227e471ac1a662429f9afbe10ff75c81ff365766903e9894d6fdc'
AND (
token = 'YH0/eXLrbvh5IVm49pKZHMOkfMK4Iwb29lKF7wSWefU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)