UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'L4n9217NSG53pgW7OrGipMdGY6I6DmeiCSLsoYJhU4E='
WHERE
key_id = 'd1499f58ff3716fd5ec4c62bd5418f7b3c0626a008752d6932efd72711dc2619'
AND (
token = 'L4n9217NSG53pgW7OrGipMdGY6I6DmeiCSLsoYJhU4E='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)