UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'XwhNtoGjf5GIPOjCeKSANOpsPGy9L4vnfaismmpnjvo='
WHERE
key_id = '1be0d1a67df53cef9d5eae2aec43902adf9aadeed3a3509ea92f813e9f8b9f05'
AND (
token = 'XwhNtoGjf5GIPOjCeKSANOpsPGy9L4vnfaismmpnjvo='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)