UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '0D9527iRt0lMhn8HCvFhHL7KNsufbvNilUjgrT9SCu8='
WHERE
key_id = '6617883af8f93f25b39ca2c10daa100ab2c10225a37a0419ae6d8cec10ca24af'
AND (
token = '0D9527iRt0lMhn8HCvFhHL7KNsufbvNilUjgrT9SCu8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)