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