UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'CnFgzNmIZqOv5P0AcZ8abOktU8aC8Z6aEmTdKS+fk7k='
WHERE
key_id = '48f60544f594654fe79c2f6df294129405860b9b4983327634b3db5915ba1a77'
AND (
token = 'CnFgzNmIZqOv5P0AcZ8abOktU8aC8Z6aEmTdKS+fk7k='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)