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