UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'GIMBOy4qnzOsuHfWw6GF3fFZskd1HiHbU+GQYpb8KAY='
WHERE
key_id = '3e529b27f8cd75893a15d22d92cf26850d5789388410f49c0608492353786478'
AND (
token = 'GIMBOy4qnzOsuHfWw6GF3fFZskd1HiHbU+GQYpb8KAY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)