UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'KUpFAq3v9QFp2vQZh28P6ugUCGodF4v+BQlsrgSla/0='
WHERE
key_id = '75100ca9320ba49698049d6926925e8d34e36e03679a8e523c3df2971e7e9964'
AND (
token = 'KUpFAq3v9QFp2vQZh28P6ugUCGodF4v+BQlsrgSla/0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)