UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'R2X3rmAH8PBTFDkLldy7Mdf6tFMIBA9NsG3te2CtKx4='
WHERE
key_id = 'bc688a6422d1e39bb82e3c3c41bcd31fd8c12d82fe9b0205aa7435f0c24adfa5'
AND (
token = 'R2X3rmAH8PBTFDkLldy7Mdf6tFMIBA9NsG3te2CtKx4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)