UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'hM+kYj6myHPRHqHTZRkr3QNZCsZkB1BVUh/V/4NUPT8='
WHERE
key_id = 'd7d66fbed33091b9c8c94602b4700ddb4bc139d1304106bbd73dc87cb69c647c'
AND (
token = 'hM+kYj6myHPRHqHTZRkr3QNZCsZkB1BVUh/V/4NUPT8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)