UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'ZXyI4n0BdxUCImbUrdt2mpxQq934u3jFjDtPQcoKBMU='
WHERE
key_id = '8216fc101f5d78d299d0de305336fa39e0a7b36a708bc1f0631f2409b69c6002'
AND (
token = 'ZXyI4n0BdxUCImbUrdt2mpxQq934u3jFjDtPQcoKBMU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)