UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'qYJbvqp4koLWoMWKmRIcsqy5k7IyWAUAd0UskvtDbrU='
WHERE
key_id = '174069174bb098551f934d975b7e94f4bf345f0fc29dce17f74da453e42f7145'
AND (
token = 'qYJbvqp4koLWoMWKmRIcsqy5k7IyWAUAd0UskvtDbrU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)