UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '/X4SlaNkL7aYvLIC7VyMlWFfUdwvAqwdOS66WBXFeY0='
WHERE
key_id = '89f71f68ca0d9646f50a40cfd11bbda9d7b3174a2518c4264a80de19ad90ba6c'
AND (
token = '/X4SlaNkL7aYvLIC7VyMlWFfUdwvAqwdOS66WBXFeY0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)