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