UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'C5svyK/l9aGHnJacIMjm/7uGXVrkksU4nZzkgkvEqmw='
WHERE
key_id = 'bfec7fdef62d968d1fc16fe6d1f8dc3300a96d73520611a9fb6d24819b378299'
AND (
token = 'C5svyK/l9aGHnJacIMjm/7uGXVrkksU4nZzkgkvEqmw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)