UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'jbsRV85ubPglrt7/wkjH8XgdpzY9suegLBTv85okcM4='
WHERE
key_id = '394f62c28c60e1771301073469a22566e298a400584895e70e64f965b9ecdb3b'
AND (
token = 'jbsRV85ubPglrt7/wkjH8XgdpzY9suegLBTv85okcM4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)