UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '8yHkq84+eUphEtKxzfnrwGCCX49RQbE5hquIYspuURw='
WHERE
key_id = 'e14915ddc9d4eaf4db0e0221f1818e254b75a8af412a9dd76b10f42048dede4a'
AND (
token = '8yHkq84+eUphEtKxzfnrwGCCX49RQbE5hquIYspuURw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)