UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'ooOKW72ANg1DgouLC3k5Zuc+stui7NG9F5hAmxvR8Yk='
WHERE
key_id = 'b470b1409dc5155192c2060195ec27cdc7e4dc6c50bef76ff9efe3324cca739b'
AND (
token = 'ooOKW72ANg1DgouLC3k5Zuc+stui7NG9F5hAmxvR8Yk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)