UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'dUhwr+x0z+maouJ7x1sYscTcyEEd9YJWi0yUAc9yUQA='
WHERE
key_id = '9543bebbbeb4b3fad3a4f917f5116e559ef5378cda8c482ff0a6ebea947a2f69'
AND (
token = 'dUhwr+x0z+maouJ7x1sYscTcyEEd9YJWi0yUAc9yUQA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)