UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'ApaiSMgIgfstkGRdfuC7emBLWgpFS7YjT6Qopr4z8Cs='
WHERE
key_id = '27fca9662c35c14e78a2b0d7ff9386c418f7e946813c7a6ca527d4627c7b442e'
AND (
token = 'ApaiSMgIgfstkGRdfuC7emBLWgpFS7YjT6Qopr4z8Cs='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)