UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'YwcxY2CLZaOwtVFKnr3M6Uypg1a2V6cCm7K7HVpGoDU='
WHERE
key_id = '0914763ff23e225cdc80b197eabe0eb95f2714a23c8c9ff46d0cf32bbad29dad'
AND (
token = 'YwcxY2CLZaOwtVFKnr3M6Uypg1a2V6cCm7K7HVpGoDU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)